﻿CREATE TABLE [dbo].[THANHPHANNL] (
    [MaDoUong] VARCHAR (10) NOT NULL,
    [MaNL]     VARCHAR (10) NOT NULL,
    [SoLuong]  INT          NULL,
    PRIMARY KEY CLUSTERED ([MaDoUong] ASC, [MaNL] ASC),
    FOREIGN KEY ([MaDoUong]) REFERENCES [dbo].[DANHMUCDOUONG] ([MaDoUong]),
    FOREIGN KEY ([MaNL]) REFERENCES [dbo].[DANHMUCNL] ([MaNL])
);

